if exists(select 1
		  from sysobjects
		  where name = 'DayStatistics')
  drop table DayStatistics
go

create table DayStatistics
(
  Id int identity(1,1) not null,
  [Date] date not null,
  CandidatesWork int null,
  CandidatesActive int null,
  CandidateTrial int null,
  Vacancies int null,
  EmployersPerson int null,
  Employers int null,
  CV int null,
  Contacts int null
  
)  
go

alter table DayStatistics add constraint PK_DayStatistics_ID primary key(Id) 
go


create unique nonclustered index IX_DayStatistics_Date on DayStatistics
       ([Date] asc)
go

